Activity Numbers and File Layouts

Finding the Activity Number

Mapper identifies and uploads files using an Actively ID. The Actively ID is the identifier for each window. For example, the Award Classification Codes window is identified by Activity ID M001010. To find the Activity ID for a current opened window, select the Help button on the Toolbar, and then select Session Information.

The Mapper Mark II import process validates each field from the import file for each window or Activity ID producing an error report before reprocessing the file.

(Click on the thumbnail to see full image.)

 

Printing the File Definitions

Once the Activity Number is located you may need information on the field content of the file layout. This can be done by selecting the following:

1. Select the Mapper icon from the toolbar.
2. Select File, Open and select the Activity Number, in this example M001010, then OK
3. Select Help,File Layout

 

 

Understanding File Layouts

File layouts are displayed in two sections. The first section displays the type of Action Status that can be used when importing records and the second section displays Field Information.

Action Status

Action Description	Action Code	Action Allowed
Add	A	Y
Update	U	Y
Delete	D	Y
Update/Add	X	Y
Clear File Before Importing		Y

 

Field Name	Key Field	Type	Len	Dec
Action		A	1
Code	Y	A	4
Description		A	30

 

Field Information

Field Name	Description of the Field
Key Field	This is the identifier of the record and once entered cannot be changed, but can be removed by selecting the Delete option. This is usually a code such as Award Code, Department Code, Personnel Groups code etc.
Type	The type of field:- A - Alphanumeric N - Numeric D - Date
Len	The maximum character length of the field
Dec	A numeric field and denotes the maximum number of decimal places

 

Actions